</td>
<td border="0"width="200 height="621" valign="top">
	  	  <div align="center">
	  	    <p><span class="Estilo2">
	  	      </span>
	  	        <embed src="http://www.crearunaweb.net/complementos/reloj04.swf" width="100" height="100" align="middle" style="" wmode="transparent" type="application/x-shockwave-flash">
	  	          <param name=wmode value=transparent />
  	            </embed></p>
	  	    <p>&nbsp;</p>
	  	  </div>
          <h2 align="center" class="arrowdiv Estilo3"><strong>Activitats d'avui </strong></h2>
<?php
$fecha=date ("j/n/Y");
$result=oci_parse($conn, "SELECT * FROM EVENTS WHERE (TIPUSE=1 OR CREAT='{$_SESSION['USUARI']}') AND to_date(DATA, 'dd/mm/YYYY')=to_date('$fecha', 'dd/mm/YYYY')"); 
		$error=oci_execute($result); 
			if(!$error){
				$er = oci_error($result);
				echo htmlentities($er['message']);
				exit;
			}	
		echo "<table border='1' cellspacing=0 cellpadding=10 bordercolor=#8181F7>";

		while ($row=oci_fetch_array($result, OCI_BOTH+OCI_RETURN_NULLS)){ 
		echo "<tr onclick=location='view.php?id=".$row['COD']."'>";
		echo "<td>";if($row["TIPUSA"]=="1"){echo"Reunio";}if($row["TIPUSA"]=="2"){echo"Conferencia";}if($row["TIPUSA"]=="3"){echo"Projecte";}echo"</td><td>";
		echo $row["ASSUMPTE"]."</td><td>".$row["HORA_INICI"]."</td></tr>";
		}
echo"</table>";
oci_free_statement($result);
?>
          <h2 align="center" class="arrowdiv Estilo3"><strong>Enlla&ccedil;os externs </strong></h2>
          <p align="center"><a href="http://www20.gencat.cat/portal/site/Educacio" target="_blank"><img src="gencat.JPG" border="0"></a></p>
          <p align="center"><a href="http://www.urv.cat/" target="_blank"><img src="urv.JPG" border="0" align="middle"></a><a href="http://www.crearunaweb.net" title="relojes web"></a>            </p>
          <p align="center">&nbsp;</p>
          <p align="center"><a href="http://www.xtec.cat/" target="_blank"><img src="xtec.JPG" border="0" align="absmiddle"></a>              </p>
          </table>
  
   <table width="1031" height="83" border="0">
    <tr>
      <td width="1021" align="center" valign="middle"><p align="center"><img src="gencat.gif" width="152" height="28"></p>
        <p align="center">&copy;1996-2010 IES Vidal i Barraquer <BR>
          Codi de centre: 43005704 </p></td>
    </tr>
  </table></td>
  </tr>
</table>
</body>
</html>
<?php 
mysql_close($link);
?>
